RetrieveClientSql

/ Assembly List / LJCDBClientLib / ObjectManager`2 / RetrieveClientSql

Namespace - LJCDBClientLib

Parameters

sql - The client SQL statement.

Returns

The data object.

Syntax

C#
public TData RetrieveClientSql(String sql)

Executes a "Retrieve" client SQL statement. (E)

Example

C#
// Selects a record with an SQL statement. private static void RetrieveClientSql(ObjectManager<Person, Persons>; personManager) { Person retValue = null; StringBuilder builder = new StringBuilder(64); builder.AppendLine("select * from PersonTest"); builder.AppendLine("where Name = 'TestName'"); string sql = builder.ToString(); retValue = personManager.RetrieveClientSql(sql); return retValue; }

// Selects a record with an SQL statement.
private static void RetrieveClientSql(ObjectManager<Person, Persons>; personManager)
{
    Person retValue = null;

    StringBuilder builder = new StringBuilder(64);
    builder.AppendLine("select * from PersonTest");
    builder.AppendLine("where Name = 'TestName'");
    string sql = builder.ToString();

    retValue = personManager.RetrieveClientSql(sql);
    return retValue;
}